SQL data2 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]("[url removed, login to view]" )

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/[url removed, login to view]"

'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: connection problem data2, 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, NFL, my sql work, mdb

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

Project ID: #1151103

5 freelancers are bidding on average $53 for this job


Thank you.

$45 USD in 1 day
(15 Reviews)

Hi abt888 I looked at your code, and need to ask you few additional questions. Please check your PMB. Thanks, John

$40 USD in 1 day
(10 Reviews)

I am interested.

$60 USD in 1 day
(0 Reviews)

Can sort it out.

$40 USD in 1 day
(0 Reviews)

hi, i can do this. i have 6 years working experience in this field. please contact.

$80 USD in 1 day
(0 Reviews)