In Progress

SQL data connection problem

when connecting to my site I get

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

/SFpool3/includes/[url removed, login to view], line 527

the common file code is

Opens the database connection (global variable 'DbConn').


sub OpenDb()

dim isPhysicalPath

dim dbDir

set DbConn = [url removed, login to view]("ADODB.Connection" )

line527-----errorr [url removed, login to view] DATABASE_CONNECTION_STRING

'If the path to the database is not physical, map it.

isPhysicalPath = false

if Len(DATABASE_FILE_PATH) >= 3 then

if Mid(DATABASE_FILE_PATH, 2, 2) = ":\" then

isPhysicalPath = true

end if

end if

if not isPhysicalPath then

dbDir = [url removed, login to view](DATABASE_FILE_PATH)



end if


[url removed, login to view] "DBQ="& dbDir & ";Driver={Microsoft Access Driver (*.mdb)}"


[url removed, login to view] "Data Source=" & dbDir & ";Provider=Microsoft.Jet.OLEDB.4.0;"

end if

end sub

the config file code is

'Location of the database.

const DATABASE_FILE_PATH = "./data/NFL.mdb"

'Database connection string (Can be Access or SQL Server).

'const DATABASE_CONNECTION_STRING = "Data Source=E:\web\survival\SFpool3\data\[url removed, login to view]; Provider=Microsoft.Jet.OLEDB.4.0;"

const DATABASE_CONNECTION_STRING = "Provider=SQLOLEDB;Data Source=tcp:[url removed, login to view];Initial Catalog=DB_26_nfl;User ID=DB_26 _nfl_user;Password=xxxxxxxx;Integrated Security=false;"

on the web the description of the error says that it is a data error, I used sql studio management to create the tables and there was no errors.

I attached the query that i ran to create the tables

Skills: Data Processing, SQL

See more: 80040e21 winhost, the string problem, tcp global, string problem, sql server open source, open source sql, open.mdb file, open mdb file, open.mdb, my sql create database, map string, jet sql, com problem, common string, common query, sql microsoft access, microsoft access sql, survival, sql microsoft, sql data, Sql code, SQL Access, open data, NFL, my sql work

About the Employer:
( 0 reviews ) St-leonard, Canada

Project ID: #1144236

3 freelancers are bidding on average $45 for this job


Please check PMB

$50 USD in 0 days
(2 Reviews)

Please, attach [url removed, login to view] file for my review. There is no wrong with query, but the ADODB operation

$50 USD in 0 days
(1 Review)

Hi, i've more than 8 years of experience in software development after completing my MCA (master in computer application, full time 3 years post graduation course). I am expert in microsoft technologies. i've worked o More

$34 USD in 1 day
(0 Reviews)