SourceTec Software

It is currently Thu Apr 24, 2014 7:56 pm

All times are UTC + 8 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
PostPosted: Thu Dec 24, 2009 7:31 pm 
Offline
Member

Joined: Thu Dec 24, 2009 6:54 pm
Posts: 1
Hello, Tech Support Team

I've purchased your Product -- Web Scroller. & need to use it with an MS SQL Database --- this database ending extension in MDF - (NOT - Access DB - (MDB))

I've read your tutorial and have tried the code for VB.NET -- Located Here- http://www.sothink.com/product/javascri ... /vbnet.htm


But this does not work . Can you email MS SQL Version to use for MDF databases. Thank You.


Example on tutorial:

/*
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<%
Dim con As OleDb.OleDbConnection
Dim strConnect As String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".\") & "\SothinkProdut.mdb;"
con= New System.Data.OleDb.OleDbConnection(strConnect)
dim rsCat as OleDb.OleDbDataAdapter = new OleDb.OleDbDataAdapter("select * from product",con)
Dim dsCat As New DataSet
Dim drCat As DataRow
Dim dtCat As DataTable
rsCat.Fill(dsCat)
dtCat = dsCat.Tables(0)
Dim i as Integer
For i = 0 to dtCat.Rows.Count - 1
drCat = dtCat.Rows(i)
Dim sName = drCat("product_name")
Dim sImage = drCat("image_path")
Dim sLink = drCat("link")
Dim sDesc = drCat("product_summary")
%>
*/



______________________________________________________________________________________________________________
I've also tried to convert your online tutorial Oledb version to SQL but this also fails to work. Can you please provide the proper Code that works with (.mdf) MS Sql database. (.mdb) database will not work - it must be (.mdf) database. Thank You.

/*
<%@ Import Namespace="System.Data" %>
<%@ Import NameSpace="System.Data.SqlClient" %>
<%
Dim con As SqlConnection
con = New SqlConnection("server='localhost'; user id='mysa'; password='mypassword'; database='SoThinkProdut'")
con= new SqlConnection(strConnect)
dim rsCat as SqlDataAdapter = new SqlDataAdapter("SELECT * from product",con)
Dim dsCat As New DataSet
Dim drCat As DataRow
Dim dtCat As DataTable
rsCat.Fill(dsCat)
dtCat = dsCat.Tables(0)
Dim i as Integer
For i = 0 to dtCat.Rows.Count - 1
drCat = dtCat.Rows(i)
Dim sName = drCat("product_name")
Dim sImage = drCat("image_path")
Dim sLink = drCat("link")
Dim sDesc = drCat("product_summary")
%>
*/


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 8 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group